Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Maintaining a schema holder

The OpenEdge Data Administration tool provides a set of ORACLE utilities that you can use to maintain a schema holder. Chapter 7, "The Data Server Tutorial," describes these utilities.

If you are using non-OpenEdge applications to change the structure of the supporting ORACLE database, be sure to update the schema image to reflect those changes. Some database operations require a certain technique to ensure that the schema image and the supporting database function together.

Table 5–7 lists common database operations and the required techniques.

Table 5–7: Database operations and the schema holder 

Database operation	Technique
Modify a column in an ORACLE table.	Update the schema image by using the OpenEdge DataServer for ORACLE utilities.
Add a column to an ORACLE table.	Update the schema image by using the OpenEdge DataServer for ORACLE utilities.
Insert a row in an ORACLE table.	Use the ORACLE sequence generator to generate a value. Assign that value to the PROGRESS_RECID column for that row. If you do not use the sequence generator, the Progress 4GL might fail when it tries to access that table.
Add an index to an ORACLE table.	Update the schema image by using the DataServer for ORACLE utilities.
Modify data definitions in the schema image.	Update the ORACLE database to reflect your changes by using the Incremental Schema Migration utility.